﻿<?xml version="1.0" encoding="utf-8" ?>
<SqlFile>
  <sentence name="MatrixUser_GetEntityByName" desc="">
    <![CDATA[
    select * from MatrixUser where [Status]=64 AND UserName=@0
    ]]>
  </sentence>
  <sentence name="MatrixModule_GetDataForTree" desc="">
    <![CDATA[
    SELECT
	    ModuleID AS Id
	    ,ModuleName AS [Text]
	    ,ParentModuleID AS ParentId
	    ,NavigationURL AS NavigateUrl
    FROM MatrixModule
    WHERE [Status]=64
	    AND ParentModuleID=@0
    ]]>
  </sentence>
  <sentence name="MatrixModule_GetListByParentID" desc="">
    <![CDATA[
    SELECT
	    *
    FROM MatrixModule
    WHERE [Status]=64
	    AND ParentModuleID=@0
    ]]>
  </sentence>
</SqlFile>